﻿DROP TABLE IF EXISTS `open_call_record`;
CREATE TABLE `open_call_record` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) DEFAULT NULL,
  `nick_name` varchar(60) DEFAULT NULL,
  `user_name` varchar(60) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `record_time` int(10) DEFAULT NULL,
  `record_type` tinyint(4) DEFAULT NULL,
  `call_number` varchar(30) DEFAULT NULL,
  `seat_number` varchar(30) DEFAULT NULL,
  `phone_number` varchar(30) DEFAULT NULL,
  `cell_number` varchar(30) DEFAULT NULL,
  `act_staff` varchar(30) DEFAULT NULL,
  `address` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `record_type` (`record_type`),
  KEY `phone_number` (`phone_number`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;